-- @owner: lihongji
-- @date: 2022/07/28
-- @testpoint: 参数算术运算符表达式测试

--step1:建序列;expect:成功
set extra_float_digits to 0;
drop sequence if exists sq_ustore_regr_intercept_0014;
create sequence sq_ustore_regr_intercept_0014 increment by 1 start with 10;

--step2:建表并插入数据;expect:成功
drop table if exists t_ustore_regr_intercept_0014 cascade;
create table t_ustore_regr_intercept_0014(
 col_1 integer,
 col_2 number(19,0),
 col_3 number(10,6)
) with (storage_type=ustore);

begin
 for i in 1..50 loop
  insert into t_ustore_regr_intercept_0014 values(
  i,
  sq_ustore_regr_intercept_0014.nextval,
  i+445.255
  );
 end loop;
end;
/
--step3:查询;expect:成功
select regr_intercept(col_2/col_3+col_3,col_2/col_2+col_3) from t_ustore_regr_intercept_0014 order by 1;
select regr_intercept(-(-col_1*-col_2-mod(col_2,col_3)),-(-col_1*-col_2-mod(col_2,col_3))) from t_ustore_regr_intercept_0014 order by 1;
select regr_intercept((-col_1*-col_2-mod(col_2,col_3)),(-col_1*-col_2-mod(col_2,col_3))) from t_ustore_regr_intercept_0014 order by 1;
select regr_intercept(col_2/col_3/col_1/col_3/col_2/col_1/col_3/col_3/col_1,col_1/col_3/col_2/col_1/col_3/col_3/col_1/col_3/col_2/col_1/col_3) from t_ustore_regr_intercept_0014 order by 1;

select regr_intercept(col_1+-col_2-col_2%col_3,col_1+-col_2-col_2%col_3) from t_ustore_regr_intercept_0014 order by 1;
select regr_intercept(col_1+col_2-col_2%col_3,col_1+col_2-col_2%col_3) from t_ustore_regr_intercept_0014 order by 1;

--step4:清理环境;expect:成功
drop sequence if exists sq_ustore_regr_intercept_0014;
drop table if exists t_ustore_regr_intercept_0014 cascade;